SQL Server 2017 Administrator's Guide by Marek Chmel Vladimir Muzny

SQL Server 2017 Administrator's Guide by Marek Chmel Vladimir Muzny

Author:Marek Chmel,Vladimir Muzny [Marek Chmel]
Language: eng
Format: epub
Tags: COM021000 - COMPUTERS / Databases / General, COM018000 - COMPUTERS / Data Processing, COM021050 - COMPUTERS / Databases / Servers
Publisher: Packt Publishing
Published: 2017-12-12T07:57:12+00:00


A big difference when comparing xEvents to the SQL Server Profiler is that event fields are not selected by default but have to be selected by an administrator. Fields are divided into common Global fields or Actions (first tab in the preceding image) and proprietary fields hidden on the Event fields tab. It's very usual that event fields are intersecting global fields so decide what fields to capture carefully.

The middle tab called Filter (Predicate) is intended for filter definitions. Unlike SQL Server Profiler, every selected event type is filtered separately. It can seem confusing, but it gives the DBA more control over what to filter. The Filters tab is shown in the following screenshot:



Download



Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.